TMSConnectionOptions Members

Name	Description
AllowImplicitConnect (inherited from TDAConnectionOptions)	Specifies whether to allow or not implicit connection opening.
ApplicationIntent	Used to specify the application workload type when connecting to a server.
ApplicationName	The name of a client application. The default value is the name of the executable file of your application.
AutoTranslate	Used to translate character strings sent between the client and server by converting through Unicode.
DefaultLockTimeout	Specifies how much time in milliseconds a transaction will wait for a lock.
DefaultSortType (inherited from TDAConnectionOptions)	Used to determine the default type of local sorting for string fields. It is used when a sort type is not specified explicitly after the field name in the TMemDataSet.IndexFieldNames property of a dataset.
DisconnectedMode (inherited from TDAConnectionOptions)	Used to open a connection only when needed for performing a server call and closes after performing the operation.
Encrypt	Specifies if data should be encrypted before sending it over the network.
FailoverPartner	Specifies the SQL Server name to which SQL Native Client will reconnect when a failover of the principal SQL Server occurs.
ForceCreateDatabase	Used to force TMSConnection to create a new database before opening a connection, if the database is not exists.
InitialFileName	Specifies the name of the main database file.
IPVersion	Use the IPVersion property to specify Internet Protocol Version. The default value is ivIPv4.
KeepDesignConnected (inherited from TDAConnectionOptions)	Used to prevent an application from establishing a connection at the time of startup.
Language	Specifies the SQL Server language name.
LocalFailover (inherited from TDAConnectionOptions)	If True, the TCustomDAConnection.OnConnectionLost event occurs and a failover operation can be performed after connection breaks.
MultipleActiveResultSets	Enables support for the Multiple Active Result Sets (MARS) technology.
MultipleConnections	Enables and disables to create additional connections to support concurrent sessions, commands and rowset objects.
NativeClientVersion	Specifies which version of SQL Native Client will be used.
NetworkLibrary	Specifies the name of the Net-Library (DLL) used to communicate with an instance of SQL Server.
NumericType (inherited from TCustomMSConnectionOptions)	Specifies the format of storing and representing the NUMERIC (DECIMAL) fields for all TCustomMSDataSets associated with the given connection.
PacketSize	Network packet size in bytes.
PersistSecurityInfo	Used to allow the data source object to persist sensitive authentication information such as a password along with other authentication information.
Provider	Used to specify a provider from the list of supported providers.
QuotedIdentifier (inherited from TCustomMSConnectionOptions)	Causes Microsoft SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings.
TrustServerCertificate	Used to enable traffic encryption without validation.
UseWideMemos (inherited from TCustomMSConnectionOptions)	Used to manage field type creation for the NTEXT data type.
WorkstationID	A string identifying the workstation.

Name

Description

AllowImplicitConnect (inherited from TDAConnectionOptions)

Specifies whether to allow or not implicit connection opening.

ApplicationIntent

Used to specify the application workload type when connecting to a server.

ApplicationName

The name of a client application. The default value is the name of the executable file of your application.

AutoTranslate

Used to translate character strings sent between the client and server by converting through Unicode.

DefaultLockTimeout

Specifies how much time in milliseconds a transaction will wait for a lock.

DefaultSortType (inherited from TDAConnectionOptions)

Used to determine the default type of local sorting for string fields. It is used when a sort type is not specified explicitly after the field name in the TMemDataSet.IndexFieldNames property of a dataset.

DisconnectedMode (inherited from TDAConnectionOptions)

Used to open a connection only when needed for performing a server call and closes after performing the operation.

Encrypt

Specifies if data should be encrypted before sending it over the network.

FailoverPartner

Specifies the SQL Server name to which SQL Native Client will reconnect when a failover of the principal SQL Server occurs.

ForceCreateDatabase

Used to force TMSConnection to create a new database before opening a connection, if the database is not exists.

InitialFileName

Specifies the name of the main database file.

IPVersion

Use the IPVersion property to specify Internet Protocol Version. The default value is ivIPv4.

KeepDesignConnected (inherited from TDAConnectionOptions)

Used to prevent an application from establishing a connection at the time of startup.

Language

Specifies the SQL Server language name.

LocalFailover (inherited from TDAConnectionOptions)

If True, the TCustomDAConnection.OnConnectionLost event occurs and a failover operation can be performed after connection breaks.

MultipleActiveResultSets

Enables support for the Multiple Active Result Sets (MARS) technology.

MultipleConnections

Enables and disables to create additional connections to support concurrent sessions, commands and rowset objects.

NativeClientVersion

Specifies which version of SQL Native Client will be used.

NetworkLibrary

Specifies the name of the Net-Library (DLL) used to communicate with an instance of SQL Server.

NumericType (inherited from TCustomMSConnectionOptions)

Specifies the format of storing and representing the NUMERIC (DECIMAL) fields for all TCustomMSDataSets associated with the given connection.

PacketSize

Network packet size in bytes.

PersistSecurityInfo

Used to allow the data source object to persist sensitive authentication information such as a password along with other authentication information.

Provider

Used to specify a provider from the list of supported providers.

QuotedIdentifier (inherited from TCustomMSConnectionOptions)

Causes Microsoft SQL Server to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings.

TrustServerCertificate

Used to enable traffic encryption without validation.

UseWideMemos (inherited from TCustomMSConnectionOptions)

Used to manage field type creation for the NTEXT data type.

WorkstationID

A string identifying the workstation.

TMSConnectionOptions Members

Properties